---
title: "SQL-120 to SQL-150: Code table read operations"
summary: All 31 cached code-table SELECT statements in mdlCodeTables.vb.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# SQL-120 to SQL-150: Code table read operations

All 31 statements in this group live in `mdlCodeTables.vb` and are simple `SELECT code/description projections with ORDER BY sorting` loaded into `CTB.CodeTable` / `ExtendedCodeMap` caches. They share a single structural pattern shown below; per-entry sections list the specific class and target table/line.

## Classification (applies to all entries in this group)

| Field | Value |
| --- | --- |
| **Operation type** | Read |
| **Execution method** | Inline SQL (SQL-132 is Stored procedure) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text (StoredProcedure for SQL-132) |
| **Business object** | `mdlCodeTables` cache classes |
| **Criteria property** | N/A (Application layer) |
| **Lifecycle method** | N/A |

## Sample SQL (common pattern)

```sql
SELECT CODE          AS Code,
       DESCRIPTION   AS Description,
       EFF_DATE      AS EffDate,
       EXP_DATE      AS ExpDate
FROM   <code_table>
ORDER  BY DESCRIPTION
```

All 31 code-table statements follow this shape against their respective `*_CODE` table (or `ADP_EMPLOYEE` / `PROVIDER_LOCATION` / `LEGAL_PERSON` for the staff and firm pick-lists). Results are cached in `CTB.CodeTable` / `ExtendedCodeMap`.*

## Entries

### SQL-120 clsALJList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-120 |
| **Class** | `clsALJList` |
| **Type** | Inline |
| **Target** | `ADP_EMPLOYEE / attorney filter` |
| **Line** | 68 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-121 clsActiveAttorneyList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-121 |
| **Class** | `clsActiveAttorneyList` |
| **Type** | Inline |
| **Target** | `ADP_EMPLOYEE + ATTORNEY_PROFILE` |
| **Line** | 102 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |
| [ATTORNEY_PROFILE](../database-tables.md#attorney_profile) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-122 clsAttorneyScheduleTypeCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-122 |
| **Class** | `clsAttorneyScheduleTypeCodes` |
| **Type** | Inline |
| **Target** | `ATTORNEY_SCHEDULE_TYPE_CODE` |
| **Line** | 134 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_SCHEDULE_TYPE_CODE](../database-tables.md#attorney_schedule_type_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-123 clsAttorneyTypeCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-123 |
| **Class** | `clsAttorneyTypeCodes` |
| **Type** | Inline |
| **Target** | `ATTORNEY_TYPE_CODE` |
| **Line** | 158 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ATTORNEY_TYPE_CODE](../database-tables.md#attorney_type_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-124 clsBodyPartCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-124 |
| **Class** | `clsBodyPartCodes` |
| **Type** | Inline |
| **Target** | `LEGAL_BODY_PART_CODE` |
| **Line** | 195 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_BODY_PART_CODE](../database-tables.md#legal_body_part_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-125 clsCancelledByCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-125 |
| **Class** | `clsCancelledByCodes` |
| **Type** | Inline |
| **Target** | `CANCELLED_BY_CODE` |
| **Line** | 220 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CANCELLED_BY_CODE](../database-tables.md#cancelled_by_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-126 clsCaseStatusCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-126 |
| **Class** | `clsCaseStatusCodes` |
| **Type** | Inline |
| **Target** | `CASE_STATUS_CODE` |
| **Line** | 243 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CASE_STATUS_CODE](../database-tables.md#case_status_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-127 clsDurationCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-127 |
| **Class** | `clsDurationCodes` |
| **Type** | Inline |
| **Target** | `DURATION_CODE` |
| **Line** | 296 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [DURATION_CODE](../database-tables.md#duration_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-128 clsFileLocationCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-128 |
| **Class** | `clsFileLocationCodes` |
| **Type** | Inline |
| **Target** | `LEGAL_FILE_LOCATION_CODE` |
| **Line** | 321 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_FILE_LOCATION_CODE](../database-tables.md#legal_file_location_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-129 clsHearingLocationCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-129 |
| **Class** | `clsHearingLocationCodes` |
| **Type** | Inline |
| **Target** | `HEARING_LOCATION_CODE` |
| **Line** | 345 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION_CODE](../database-tables.md#hearing_location_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-130 clsHearingLocationList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-130 |
| **Class** | `clsHearingLocationList` |
| **Type** | Inline |
| **Target** | `HEARING_LOCATION` |
| **Line** | 367 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-131 clsLegalStaffList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-131 |
| **Class** | `clsLegalStaffList` |
| **Type** | Inline |
| **Target** | `ADP_EMPLOYEE` |
| **Line** | 402 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-132 clsLegalStaffList (proc path)

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-132 |
| **Class** | `clsLegalStaffList (proc path)` |
| **Type** | StoredProc |
| **Target** | `pk80001_legalnet.SelectLegalEmployees` |
| **Line** | 416 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-133 clsMessageAttorneyList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-133 |
| **Class** | `clsMessageAttorneyList` |
| **Type** | Inline |
| **Target** | `ADP_EMPLOYEE + ATTORNEY_PROFILE` |
| **Line** | 444 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |
| [ATTORNEY_PROFILE](../database-tables.md#attorney_profile) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-134 clsNatureCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-134 |
| **Class** | `clsNatureCodes` |
| **Type** | Inline |
| **Target** | `NATURE_CODE` |
| **Line** | 482 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [NATURE_CODE](../database-tables.md#nature_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-135 clsNoteCategoryCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-135 |
| **Class** | `clsNoteCategoryCodes` |
| **Type** | Inline |
| **Target** | `NOTE_CATEGORY_CODE` |
| **Line** | 506 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [NOTE_CATEGORY_CODE](../database-tables.md#note_category_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-136 clsOutcomeGroundsCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-136 |
| **Class** | `clsOutcomeGroundsCodes` |
| **Type** | Inline |
| **Target** | `OUTCOME_GROUNDS_CODE` |
| **Line** | 530 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_GROUNDS_CODE](../database-tables.md#outcome_grounds_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-137 clsOutcomeIssueCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-137 |
| **Class** | `clsOutcomeIssueCodes` |
| **Type** | Inline |
| **Target** | `OUTCOME_ISSUE_CODE` |
| **Line** | 567 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OUTCOME_ISSUE_CODE](../database-tables.md#outcome_issue_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-138 clsOutsideCouselFirmList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-138 |
| **Class** | `clsOutsideCouselFirmList` |
| **Type** | Inline |
| **Target** | `PROVIDER_LOCATION` |
| **Line** | 591 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PROVIDER_LOCATION](../database-tables.md#provider_location) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-139 clsOutsideCouselList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-139 |
| **Class** | `clsOutsideCouselList` |
| **Type** | Inline |
| **Target** | `LEGAL_PERSON` |
| **Line** | 613 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LEGAL_PERSON](../database-tables.md#legal_person) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-140 clsOrderTypeCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-140 |
| **Class** | `clsOrderTypeCodes` |
| **Type** | Inline |
| **Target** | `ORDER_TYPE_CODE` |
| **Line** | 654 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ORDER_TYPE_CODE](../database-tables.md#order_type_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-141 clsOtherFirmTypeCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-141 |
| **Class** | `clsOtherFirmTypeCodes` |
| **Type** | Inline |
| **Target** | `OTHER_FIRM_TYPE_CODE` |
| **Line** | 679 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [OTHER_FIRM_TYPE_CODE](../database-tables.md#other_firm_type_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-142 clsPetitionerRespondentCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-142 |
| **Class** | `clsPetitionerRespondentCodes` |
| **Type** | Inline |
| **Target** | `PETITIONER_RESPONDENT_CODE` |
| **Line** | 703 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PETITIONER_RESPONDENT_CODE](../database-tables.md#petitioner_respondent_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-143 clsRequestedByCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-143 |
| **Class** | `clsRequestedByCodes` |
| **Type** | Inline |
| **Target** | `REQUESTED_BY_CODE` |
| **Line** | 727 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUESTED_BY_CODE](../database-tables.md#requested_by_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-144 clsRequestIssueCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-144 |
| **Class** | `clsRequestIssueCodes` |
| **Type** | Inline |
| **Target** | `REQUEST_ISSUE_CODE` |
| **Line** | 751 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUEST_ISSUE_CODE](../database-tables.md#request_issue_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-145 clsRequestTypeCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-145 |
| **Class** | `clsRequestTypeCodes` |
| **Type** | Inline |
| **Target** | `REQUEST_TYPE_CODE` |
| **Line** | 896 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REQUEST_TYPE_CODE](../database-tables.md#request_type_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-146 clsReviewLevelCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-146 |
| **Class** | `clsReviewLevelCodes` |
| **Type** | Inline |
| **Target** | `REVIEW_LEVEL_CODE` |
| **Line** | 933 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [REVIEW_LEVEL_CODE](../database-tables.md#review_level_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-147 clsSAIFStaffList

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-147 |
| **Class** | `clsSAIFStaffList` |
| **Type** | Inline |
| **Target** | `ADP_EMPLOYEE` |
| **Line** | 958 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-148 clsScheduleStatusCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-148 |
| **Class** | `clsScheduleStatusCodes` |
| **Type** | Inline |
| **Target** | `SCHEDULE_STATUS_CODE` |
| **Line** | 999 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [SCHEDULE_STATUS_CODE](../database-tables.md#schedule_status_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-149 clsScheduleTypeCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-149 |
| **Class** | `clsScheduleTypeCodes` |
| **Type** | Inline |
| **Target** | `SCHEDULE_TYPE_CODE` |
| **Line** | 1040 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [SCHEDULE_TYPE_CODE](../database-tables.md#schedule_type_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

### SQL-150 clsScheduleALJList clsServiceCodes

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-150 |
| **Class** | `clsScheduleALJList / clsServiceCodes` |
| **Type** | Inline |
| **Target** | `ADP_EMPLOYEE (1104) / SERVICE_CODE (1133)` |
| **Line** | 1104, 1133 |

#### Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [ADP_EMPLOYEE](../database-tables.md#adp_employee) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |
| [SERVICE_CODE](../database-tables.md#service_code) | SELECT | CODE, DESCRIPTION, EFF_DATE, EXP_DATE |

#### Sources
- `SAIF.Business.Claim.Legal\mdlCodeTables.vb`

---

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- See per-SQL-ID Sources subsections above for exact .vb file/line citations.